﻿CREATE TABLE [dim].[Client] (
    [ClientId]        INT            IDENTITY (1, 1) NOT NULL,
    [ClientCode]      VARCHAR (10)   NOT NULL,
    [ClientName]      NVARCHAR (100) NOT NULL,
    [ClientGroupId]   INT            NOT NULL,
    [ClientGroupCode] VARCHAR (10)   NOT NULL,
    [ClientGroupName] NVARCHAR (100) NOT NULL,
    [SalesGroupId]    INT            NOT NULL,
    [SalesGroupCode]  VARCHAR (10)   NOT NULL,
    [SalesGroupName]  NVARCHAR (100) NOT NULL,
    [IsInferedMember] BIT            NOT NULL,
    [RowChecksumMD5]  CHAR (36)      NOT NULL,
    [RowAuditId]      INT            NOT NULL,
    PRIMARY KEY CLUSTERED ([ClientId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

